Cash Flow Analysis

Objective

The Cash Flow Analysis option enables users to monitor receipts, disbursements, and available funds as needed, based on previously set parameters; the resulting amounts are displayed in tables. Functions include a drill-down to more detailed information, such as the related transactions list.

Other items like a refresh schedule for the analysis table can be configured.

This option can also be accessed through an applet on the maestro* dashboard.

 

For instructions on configuring and using the applet, refer to the Cash Flow Analysis How To document.

 

prerequisites

• General Settings (General Ledger > General > Cash Flow Analysis)
• Chart of Accounts
• Bank Accounts
• Annual Budgets
• Payroll / Labour
• Line Configuration
• Display Layout Configuration
• Define Manual Adjustment Types

 

Icons

Icon	Title	Used to
	Refresh	Refresh the analysis information based on the given parameters.
	Configuration	Access the Options window where users can indicate settings such as how often the analysis data should be refreshed and whether bank accounts appearing in the tables should be grouped. Click here for a description of the Options window.

 

STEPS

maestro* > Accounting > Financial Management > Cash Flow Analysis > Cash Flow Analysis

 

Analyzing the Cash Flow

1. Enter the information in the fields as needed.

 

Field	Description
Date	Date for which the analysis must be done.
Display Layout	Layout used to present the cash flow information.
Grouping	Account group that will be displayed in the analysis, as configured in the Options window. Note: Internal bank accounts are excluded from the available accounts list.

2. Click the Refresh button to access the cash flow analysis layout.

The analysis is presented in accordance with the lines and columns parameters previously set in maestro*, in the Line Configuration and Display Layout Configuration options. For additional information on the lines’ rules and calculation methods, as well as the periods defined by the columns, go to the corresponding Help (F1) documents.

The analysis is displayed on tabs: the first tab, All Accounts, summarizes the amounts of all the accounts included in the group; every other tab provides data specific to an account.   On each tab, in the top left corner of the layout, the Line of Credit field indicates the available amount. The Line of Credit amount can be entered in the Bank Accounts option.

3. In the table, double-click on a cell to obtain detailed information on a specific amount.

It is possible to drill down on every cell in the analysis, except for the opening and closing balances. Drilling will display the transaction list related to the amount. A red square in the top right corner of a cell indicates that transactions have been posted. Previous periods only contain posted transactions.

4. Repeat steps 1 and  2 to view different account groupings.
5. Click Quit to exit the window.

 

See also

Procedures

• Manual Adjustments

How To

• Cash Flow Analysis

 

 

Appendix

Options window

The Options window is used to define settings specific to the Cash Flow Analysis window, such as Automatic Refresh, Bank Descriptions, etc.

1. Enter the required information as needed.

 

Field	Description
Automatic Refresh	Indicate when the analysis’s information should be updated, whether Each Hour, Each Day, or not at all (in which case, leave the boxes empty). The analysis is recalculated each time the option is launched. Note: Check the Display Last Refresh box to show when the information was last updated.
Under Line of Credit	Define how Opening and Closing Balance amounts are displayed if they exceed the available line of credit. Background and Text colours can be set by clicking on the colour itself. Note: Click Reset Colours to Default to revert to the original settings.
Bank Description	Determine what will appear in the tabs’ header, next to the GL account number: Available information: Bank Name Account Description Account Use Note: The Bank Name and Account Use are specified in the Bank Accounts option, while the Account Description refers to the corresponding GL account as identified in the Chart of Accounts option.
Account Grouping	Combine bank accounts into groups to facilitate the cash flow analysis; accounts can be grouped to reflect the company’s needs. In the Account Grouping section, click the New icon. Enter a name for this group in the Template field. Check the box matching the accounts that should be included in the group. Click the Save icon. These groups can be selected through the Grouping drop-down menu on the Cash Flow Analysis window.

2. Click Ok to exit the Options window and return to the Cash Flow Analysis window.

 

Last modification: March 19, 2025